<?php 
include "../public/header.php";
//引入数据库文件
include "../public/common.php";
?>


 <!-- 右侧内容块 -->

<div class="col-md-9">
	<h1 class="page-header">会员信息</h1>
	<!-- 显示会员信息 -->
	<table class="table table-bordered table-hover table-striped text-center">
		<tr>
			<td>编号</td>
			<td>会员名</td>
			<td class="warning">积分数</td>
			<td class="danger">肤质</td>
			<td class="info">电话</td>
			<td>性别</td>
			<td>生日</td>
			<td>详细信息</td>
			<!-- <td>邮箱</td>
			<td>地址</td>
			<td>家庭状况</td> -->
		</tr>
		<?php 
			header("Content-type:text/html;charset=utf8");
	     	$sql = "select * from card,user where card.card_id = user.card_id;";
	     	if($result = $conn->query($sql)) {
	     		while($row = $result->fetch_assoc()) {
	    ?>
	    	<tr>
	    		<td><?php echo $row['user_id'] ?></td>
	    		<td><?php echo $row['user_name'] ?></td>
	    		<td class="warning"><?php echo $row['card_integral'] ?></td>
	    		<td class="danger"><?php echo $row['user_face'] ?></td>
	    		<td class="info"><?php echo $row['user_tel'] ?></td>
	    		<td><?php echo $row['user_sex'] ?></td>
	    		<td><?php echo $row['user_data'] ?></td>
	    		<td>
	    			<button type="button" class="btn btn-primary" data-toggle="popover" data-placement="bottom" data-content="
	    			<?php echo "邮箱:{$row['user_email']}"  ?>
	    			<?php echo "地址：{$row['user_add']}"  ?>
	    			<?php echo "家庭状况：{$row['user_family']}"  ?>
	    			">详细信息</button>
	    		</td>
	    		
	    	</tr>
	    <?php
	     		}
	     	}
     	 ?>
	</table>
     
</div>
<script type="text/javascript">
	$(function () {
  $('[data-toggle="popover"]').popover()
})
</script>
<?php
include "../public/footer.php";
 ?>